Skip to main content

Excel Data

The Excel output node appends the selected variables as a row to an Excel workbook (.xlsx). It is the CSV output with a spreadsheet as its file, see CSV Data for the selection of folder, file name and variables.

Configuration​

  1. Select the folder and enter a file name that ends in .xlsx, e.g. orders.xlsx. The format follows the ending: with .csv the same node writes a CSV file.
  2. Enter the sheet to append to. It is created if it does not exist; empty means the first sheet.
  3. Select the variables that become columns, and the names of the columns.

How a row is written​

  • The first row of the sheet is the header. A new workbook or sheet gets the column names as its header.
  • A value is put into the column of the same name, not the same position. You may move columns around in Excel, the next row still lands in the right one.
  • A name the header does not have becomes a new column at the right; older rows stay empty there.
  • A column that has no value in this row stays empty.
  • Every value is written as text: 007 keeps its zeros, a phone number stays as it is, and a text starting with = is not run as a formula.

Limits​

  • Appending reads and writes the whole workbook, because the file format has no append. A workbook larger than 20 MB is not appended to (the node takes the activity error edge). Use a CSV file for a log that grows without end.
  • Rows that arrive at the same time are written one after the other.
  • A file that is not a workbook (for example a CSV file that was renamed) is never overwritten: the node takes the activity error edge, and the application log names the file.
  • The old .xls format and .xlsm (macros) are not written as a workbook: with these endings the node writes CSV text. Use .xlsx.
  • Sheet names have at most 31 characters and none of : \ / ? * [ ].

Reading it again​

A workflow with an Excel input and follow switched on wakes when this node appended a row. Together they form a pipeline between two workflows.